Database (Backend Management)
Our backend provides all business functionality like front end processing, image processing, business processing and rendering required database queries. Our backend will also expose APIs for saving different states of DB objects.
- Client : xamin
- Category : Healthcare
- Website : xamin@gmail.com
- Date : 29/08/2019
Database Schema
For saving different states of application as well as the user related data, the application will use a relational database like MySql or PostgreSQL. It will have tables for users and their details, logos created and favorited by them, and different states of logos during editing.
Our Core DB Logic
We have built different APIs on the backend to do core business logic. The APIs are divided into different modules as shown below. Each module will have functions for core logic related to the module. We built DB logic for each of these functions as follows:
Our Core DB Logic
- GetSettings: Get account settings
- SaveSettings: Save account settings
- DeleteAccount: Delete account
- GetUserLogos: Get all logos edited or favorited by the user
- DeleteLogo: Delete a logo saved by user
- SaveUserInfo: Save company details (used for logo creation)
- SaveColor: Save brand colors (used for logo creation)
- SaveIcon: Save preferred icons for brand (used for logo creation)
- GenerateLogos: Generate a list of logos based on user saved criteria
- MarkFavorite: Mark a logo as favorite (save it to user’s logos)
- DownloadLogo: Generate files for downloading a logo
- GetCanvas: Get canvas object for a logo (to enable editing of logo)
- SaveCanvas: Save canvas object after user edits logo
- GetRelatedWords: Generate and get a list of words similar to user’s search term
- GetIcons: Get a list of icons based on user’s search keyword
- GetShapes: Get a list of shapes to show in editor or logo creation flow
- GetFonts: Get a list of fonts to show in editor
- GetTemplates: Get a list of templates to show in editor
- GetBackgrounds: Get a list of backgrounds to show in editor
![Database Backend Management](https://beta.akratech.com/wp-content/uploads/2023/11/Analysis-1-scaled.webp)
Features
- Forms Management
- Document Management
- Third-Party Integration
- Reports and Growth Charts
- Two-way communication -SMS, email
Please note that more advanced functionality like image optimizing, rescaling, rotating images, etc. can also be added to this class depending on the requirement. These advanced operations are achieved by importing different libraries in python or nodejs that provide this functionality. Note: Some operations of image processing can also be applied on front end via JavaScript in the browser. For example, applying filters on the logo can be achieved in the frontend by adding an image on the canvas object and applying filters on the image.
![](https://beta.akratech.com/wp-content/uploads/2023/11/Image-viewer-bro-1-scaled.webp)
Please note that more advanced functionality like image optimizing, rescaling, rotating images, etc. can also be added to this class depending on the requirement. These advanced operations are achieved by importing different libraries in python or nodejs that provide this functionality. Note: Some operations of image processing can also be applied on front end via JavaScript in the browser. For example, applying filters on the logo can be achieved in the frontend by adding an image on the canvas object and applying filters on the image.
![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
JAMES
- Founder![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
RAN
- Founder![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
MAN SETH
- Founder![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
STEVEN LASH
- Founder, KidComputers![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
DAVID MCKEE
- Founder, , Inteliqual![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
DANNY GLENNON
- CEO -Ptbizfit![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
PAUL D
- CEO -Fleuronguide![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
KEVIN GRAY
- CEO - Penny Miller![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
ERIKA MARTINEZ
- CEO - Denver Public School![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
JOEL
- CEO - ACME Productions![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
DR HISHAM AL DABAH
- CEO![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
JOSEPH RICE
- Sabaa.org, USA![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
Natasha Green
- Founder | WEInterveneI am thrilled to share my experience with Akra Tech, a company that has been instrumental in my EdTech startup, We Intervene, since July 2020. Working with Ashraf has been a pleasure, as I appreciated not having to spend time finding and vetting designers and developers. This allowed me to focus on self-funding and developing my business. Ashraf’s dedication to understanding my needs and providing valuable insights made him a true partner in the project. His team was also incredibly responsive and proactive in keeping me informed of their progress.
![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
Aida Ahmadzadegan-Shapiro
- CEO![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/04-min.jpg)
Ricardo Vidal | PhDHead of Product
- CEOI’m delighted to recommend Akratech for their exceptional web development services. They have helped us swiftly build our internal web applications and customer-facing websites. Their expertise, responsiveness, and versatility have been essential to building software for our rapidly-growing company. We are extremely satisfied and look forward to continue working with them in the future.
![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/03-min.jpg)
Walhan Bobe
- Business AdvisorIt was a pleasure using your template. Your template saved us hours of frustration, your template is fabulous. It worked like a champ. Every page was exactly how I wanted.
![image-testimonial](https://beta.akratech.com/wp-content/uploads/2019/09/01-min.jpg)
Mark McManus
- COOMy good friend suggested that I purchase this template. I did and was delighted that I got it. Formatting the products now becomes extremely simple, and convenient.
Performance and Security
To achieve high performance in the application, we recommend following best practices in code in both frontend and backend. Some examples of best practices that can be followed are:
- Writing high performance JavaScript code in the front end by using best practices in JavaScript and frameworks like React.
- On the client side, wherever effects and animations are used, make sure to get higher frames per seconds by using various tricks to write performant animations.
- Keep the build size of bundles as small as possible by using various build tools, using lazy loading and by compressing them before getting from the server.
- Using reverse proxy like Nginx to serve static files faster and applying gzip compression on them.
- Writing performant code in the backend to avoid any bottlenecks in performance.
- Using CDNs to serve static files faster based on location of end users.
- Optimizing database performance by writing queries that perform better and adding appropriate indexing on tables.
- Using cache wherever it is appropriate to reduce processing time for repeated calls to the server.
- Applying various other best practices on all levels i.e, Frontend, backend, database, and deployment.
Our Core DB Logic
We have prepared Wireframes and Front end design using Adobe XD, Photoshop in coming up with the initial design and mockup and followed by further design revisions
- Design graphic user interface elements, like menus and tabs
- Illustrate design ideas using storyboards, process flows
- Built page elements such custom graphics and illustrations
- Developed UI mockups and prototypes that clearly illustrate how sites function and look like
- Layout adjustments based on user feedbac
Our Development Team came up with the technical architecture followed by data flow design, process flow design, flow charts, and technical documentation
We used PHP Tech Stack with Application Programming Interfaces (APIs) which let “Plug in” to other Useful Features. Through our highly skilled and certified developers, we developed custom solutions and technical services on a wide range of requirements and thereby exceeding the client’s expectations. This has all been achieved through our efficient coding best practices, development processes, implementation guidelines, technical maturity & end to end delivery.
We performed a comprehensive test strategy since technology stack undergo constant changes due to upgrades in web and mobile technologies. Our testing included exhaustive functional and non-functional testing, manual and automation testing besides performance and security testing. Our automated Application Testing and Performance Analysis ensured testing the applications on multiple devices and form factors and make the testing process quick, efficient, reliable, repeatable and reusable.
Our comprehensive application testing coverage included the following:
- Functional testing including UI testing for native, hybrid and web applications
- Cross Browser Testing across various browser platforms
- Cross platform testing: iOS, Android, Windows, BlackBerry and HTML5
- Non-functional testing: Performance, stability, security and compliance
- Usability and compatibility testing
Recent Portfolio
![Inventory-Forecasting-with-Tableau](https://beta.akratech.com/wp-content/uploads/2023/11/Inventory-Forecasting-with-Tableau.webp)
Inventory Forecasting with tableau
Data Visualization
![](https://beta.akratech.com/wp-content/uploads/2019/09/akrahealth.png)
Akra Health Portal
telehealth services
![Farlanes](https://beta.akratech.com/wp-content/uploads/2023/11/Farlanes.webp)
Farlanes Online Classroom
online classroom
![](https://beta.akratech.com/wp-content/uploads/2019/09/Route-optimization-1.png)
Delivery Routing Application
Data Science
![](https://beta.akratech.com/wp-content/uploads/2019/09/student-conselling-1.png)
Student Counselling Portal
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2023/03/privacy-26.png)
GDPR compliance software
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2019/09/Route-optimization-1.png)
Visual Forecasting
SAAS
![](https://beta.akratech.com/wp-content/uploads/2023/11/Online-student-management-portal.png)
Online Student Training Portal
Learning Management
![Database-Backend-Management](https://beta.akratech.com/wp-content/uploads/2023/11/Database-Backend-Management.webp)
Database (Backend Management)
Healthcare
![Problem-Oriented-Health-Application-Portal](https://beta.akratech.com/wp-content/uploads/2023/11/Problem-Oriented-Health-Application-Portal.webp)
Problem Oriented Health Application
Healthcare
![Farlanes](https://beta.akratech.com/wp-content/uploads/2023/11/Farlanes.webp)
Farlanes Online Classroom Mobile Application
Healthcare
![Pricing Prediction](https://beta.akratech.com/wp-content/uploads/2023/11/3.Cover-Pricing-Prediction-782x437-Color-min.webp)
Pricing Prediction
SAAS
![Web-Crawling](https://beta.akratech.com/wp-content/uploads/2023/11/Web-Crawling.webp)
Web Scraping with Python
Data Scraping
![course_managment](https://beta.akratech.com/wp-content/uploads/2023/11/course_managment.webp)
Course Management
Data Scraping
![Akra-HealthTelemedicine-App](https://beta.akratech.com/wp-content/uploads/2023/11/Akra-HealthTelemedicine-App.webp)
Akra Health Tele Medicine App
Healthcare
![Transcribe-Flow](https://beta.akratech.com/wp-content/uploads/2023/11/Transcribe-Flow.webp)
Transcribe Flow
Healthcare
![Gift-Pool](https://beta.akratech.com/wp-content/uploads/2023/11/Gift-Pool.webp)
Gift Pool
E-commerce
![Hospital-Management](https://beta.akratech.com/wp-content/uploads/2023/11/Hospital-Management.webp)
In House Hospital Management System
Healthcare
![Data-Visualization-Tableau](https://beta.akratech.com/wp-content/uploads/2023/11/Data-Visualization-Tableau.webp)
Data Visualisation & Analytics
Data Visualization
![EMR](https://beta.akratech.com/wp-content/uploads/2023/11/EMR-Client-Application.webp)
EMR Client Application
Data Visualization
![Inventory-Forecasting](https://beta.akratech.com/wp-content/uploads/2023/11/Inventory-Forecasting.webp)
Inventory Forecasting
Data Science
![ERP-Purchasing-Portal](https://beta.akratech.com/wp-content/uploads/2023/11/ERP-Purchasing-Portal.webp)
ERP Purchasing Portal
Data Science
![API Integration](https://beta.akratech.com/wp-content/uploads/2023/11/API-Development.webp)
API Development
Data Science
![Zoho Integration](https://beta.akratech.com/wp-content/uploads/2023/11/zoho.webp)
Zoho Integration
Data Science
![](https://beta.akratech.com/wp-content/uploads/2023/11/air-quality-1.png)
Air Quality Check Voting App
Healthcare
![Dental Practice Mangement](https://beta.akratech.com/wp-content/uploads/2023/11/DentalManagement.jpg)
Company Formation Portal
E-commerce
![Dental Practice Mangement](https://beta.akratech.com/wp-content/uploads/2023/11/DentalManagement.jpg)
Story Write for Kids
SAAS
![](https://beta.akratech.com/wp-content/uploads/2023/03/privacy-26.png)
GDPR compliance software
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2019/09/student-conselling-1.png)
Student Counselling Portal
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2023/03/privacy-26.png)
GDPR compliance software
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2019/09/Route-optimization-1.png)
Delivery Routing Application
Data Science
![](https://beta.akratech.com/wp-content/uploads/2023/03/privacy-26.png)
GDPR compliance software
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2019/09/Route-optimization-1.png)
Visual Forecasting
SAAS
![Web-Crawling](https://beta.akratech.com/wp-content/uploads/2023/11/Web-Crawling.webp)
Web Scraping with Python
Data Scraping
![Inventory-Forecasting](https://beta.akratech.com/wp-content/uploads/2023/11/Inventory-Forecasting.webp)
Inventory Forecasting
Data Science
![Web-Crawling](https://beta.akratech.com/wp-content/uploads/2023/11/Web-Crawling.webp)
Web Scraping with Python
Data Scraping
![Inventory-Forecasting-with-Tableau](https://beta.akratech.com/wp-content/uploads/2023/11/Inventory-Forecasting-with-Tableau.webp)
Inventory Forecasting with tableau
Data Visualization
![Data-Visualization-Tableau](https://beta.akratech.com/wp-content/uploads/2023/11/Data-Visualization-Tableau.webp)
Data Visualisation & Analytics
Data Visualization
![](https://beta.akratech.com/wp-content/uploads/2023/03/privacy-26.png)
GDPR compliance software
web scrapping
![Gift-Pool](https://beta.akratech.com/wp-content/uploads/2023/11/Gift-Pool.webp)
Gift Pool
E-commerce
![Dental Practice Mangement](https://beta.akratech.com/wp-content/uploads/2023/11/DentalManagement.jpg)
Company Formation Portal
E-commerce
![Database-Backend-Management](https://beta.akratech.com/wp-content/uploads/2023/11/Database-Backend-Management.webp)
Database (Backend Management)
Healthcare
![Problem-Oriented-Health-Application-Portal](https://beta.akratech.com/wp-content/uploads/2023/11/Problem-Oriented-Health-Application-Portal.webp)
Problem Oriented Health Application
Healthcare
![Akra-HealthTelemedicine-App](https://beta.akratech.com/wp-content/uploads/2023/11/Akra-HealthTelemedicine-App.webp)
Akra Health Tele Medicine App
Healthcare
![Hospital-Management](https://beta.akratech.com/wp-content/uploads/2023/11/Hospital-Management.webp)
In House Hospital Management System
Healthcare
![](https://beta.akratech.com/wp-content/uploads/2023/11/air-quality-1.png)
Air Quality Check Voting App
Healthcare
![Dental Practice Mangement](https://beta.akratech.com/wp-content/uploads/2023/11/DentalManagement.jpg)
Story Write for Kids
SAAS
![](https://beta.akratech.com/wp-content/uploads/2023/11/Online-student-management-portal.png)
Online Student Training Portal
Learning Management
![Farlanes](https://beta.akratech.com/wp-content/uploads/2023/11/Farlanes.webp)
Farlanes Online Classroom
online classroom
![](https://beta.akratech.com/wp-content/uploads/2019/09/akrahealth.png)
Akra Health Portal
telehealth services
![](https://beta.akratech.com/wp-content/uploads/2019/09/student-conselling-1.png)
Student Counselling Portal
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2023/03/privacy-26.png)
GDPR compliance software
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2019/09/Route-optimization-1.png)
Visual Forecasting
SAAS
![Dental Practice Mangement](https://beta.akratech.com/wp-content/uploads/2023/11/DentalManagement.jpg)
Story Write for Kids
SAAS
![](https://beta.akratech.com/wp-content/uploads/2019/09/akrahealth.png)
Akra Health Portal
telehealth services
![](https://beta.akratech.com/wp-content/uploads/2019/09/student-conselling-1.png)
Student Counselling Portal
web scrapping
![](https://beta.akratech.com/wp-content/uploads/2023/03/privacy-26.png)
GDPR compliance software
web scrapping